SET QUOTED_IDENTIFIER ON
GO
SET ANSI_NULLS ON
GO
CREATE PROCEDURE [dbo].[usp_CheckEmployeeIDIsExist]
    (
      @JOL_Employee_Account VARCHAR(50)--这个参数这里代表的不是账号，是身份证号，这样是为了使函数重用
    )
AS 
    SELECT  COUNT(JOL_Employee_IDCardNo)
    FROM    dbo.JOL_Employee
    WHERE   JOL_Employee_IDCardNo = @JOL_Employee_Account
GO
